{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cover","Config","Generator"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":33,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":47,"n_cols":16,"rows_kept":47,"cut":false,"hidden":false,"merged":[[23,0,23,2],[5,0,5,2],[2,3,2,4],[2,5,2,13],[12,1,12,2],[11,1,11,2],[6,0,6,2],[0,0,0,13],[1,0,1,13],[3,1,3,2],[3,3,3,4],[3,5,3,13],[2,1,2,2],[31,0,31,2],[36,0,36,2],[38,0,38,2],[41,0,41,2],[26,0,27,2],[32,0,32,2],[35,0,35,2],[33,0,33,2],[34,0,34,2],[37,0,37,2],[40,0,40,2],[39,0,39,2],[29,0,29,2],[22,0,22,2],[24,0,24,2],[21,0,21,2],[18,0,18,2],[29,3,29,13],[27,3,27,13],[24,3,24,13],[21,3,21,13],[18,3,18,13],[19,0,19,2],[19,3,19,13],[23,3,23,13],[22,11,22,12],[22,6,22,7],[20,0,20,2],[20,9,20,13],[8,1,8,2],[9,1,9,2],[14,0,14,2],[15,3,17,13],[15,0,17,2],[14,3,14,13],[12,3,12,13]]}
["COMPANY PROJECT NAME\nDescription of the work\nAdress",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"${markup}"]
["${company_project_document_type:label}"]
["Date","${startdate}",null,"Workflow name",null,"${name}"]
[null,null,null,"Document name",null,"${target.name}"]
[]
["GENERAL STATUS",null,null,"Project","Type","Discipline","Number","Révision"]
[{"$f":"IFERROR(IF(A46=\"POSITIVE\",Positive,IF(A46=\"NONE\",None&A45,IF(A46=\"NEGATIVE\",Negative,IF(A46=\"ABORTED\",Aborted,\"\")))),\"\")&IFERROR(CHAR(10)&IF(A47=\"Current\",Current,Previous),\"\")","v":"\nObsolete"},null,null,"PRJ","${company_project_document_type}","${company_project_package}","${company_project_number}","${company_project_revision}",null,null,null,null,null,null,null,"Don't forget to replace PRJ by project code !"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"${prevWorkflows.start}"]
["${card.company_project_revision}","${card.completedate}",null,"${company_project_review_description}"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"${prevWorkflows.end}"]
["${card.company_project_revision}","${card.completedate}",null,"${company_project_review_description}"]
["REVISION","DATE",null,"REVIEW COMMENTS"]
[]
["TITLE",null,null,"${company_project_title}"]
["DESCRIPTION",null,null,"${company_project_description}"]
[]
[]
["DISCIPLINE",null,null,"${company_project_package:label}"]
["MANUFACTURER",null,null,"${company_project_manufacturer}"]
["SUPPLIED",null,null,"${company_project_supplier}",null,null,null,null,"MARQUE","${company_project_product}"]
["REF. SPEC.",null,null,"${company_project_specifications}"]
["CONFORMITY",null,null,"${company_project_conformity:label}",null,null,"ECHANTILLON",null,"${company_project_sample:label}",null,null,"IMPACT FINANC.",null,"${company_project_financial_impact:label}"]
["PLAN",null,null,"${company_project_plan}"]
["ANNEXES",null,null,"${company_project_annexes}"]
[]
["REMARKS"]
[null,null,null,{"$f":"IF(D35<>\"Y\",IF(D35<>\"\",\"[\"&D32&\"] \"&D35&CHAR(10),\"\")&\nIF(E35<>\"\",\"[\"&E32&\"] \"&E35&CHAR(10),\"\")&\nIF(F35<>\"\",\"[\"&F32&\"] \"&F35&CHAR(10),\"\")&\nIF(G35<>\"\",\"[\"&G32&\"] \"&G35&CHAR(10),\"\")&\nIF(H35<>\"\",\"[\"&H32&\"] \"&H35&CHAR(10),\"\")&\nIF(I35<>\"\",\"[\"&I32&\"] \"&I35&CHAR(10),\"\")&\nIF(J35<>\"\",\"[\"&J32&\"] \"&J35&CHAR(10),\"\")&\nIF(K35<>\"\",\"[\"&K32&\"] \"&K35&CHAR(10),\"\")&\nIF(L35<>\"\",\"[\"&L32&\"] \"&L35&CHAR(10),\"\")&\nIF(M35<>\"\",\"[\"&M32&\"] \"&M35&CHAR(10),\"\")&\nIF(N35<>\"\",\"[\"&N32&\"] \"&N35&CHAR(10),\"\"),\"\")","v":"[AR] $(actions.company_project_action_ar.company_project_comment)\n[STAB] $(actions.company_project_action_stab.company_project_comment)\n[MEP] $(actions.company_project_action_mep.company_project_comment)\n[PM] $(actions.company_project_action_pm.company_project_comment)\n"}]
[]
["STATUSES",null,null,{"$f":"Config!B16&\" (\"&Config!A16&\")\"\n&IF(Config!A17<>\"Undefined\",\" / \"&Config!B17&\" (\"&Config!A17&\")\",\"\")\n&IF(Config!A18<>\"Undefined\",\" / \"&Config!B18&\" (\"&Config!A18&\")\",\"\")\n&IF(Config!A19<>\"Undefined\",\" / \"&Config!B19&\" (\"&Config!A19&\")\",\"\")\n&IF(Config!A20<>\"Undefined\",\" / \"&Config!B20&\" (\"&Config!A20&\")\",\"\")\n&IF(Config!A21<>\"Undefined\",\" / \"&Config!B21&\" (\"&Config!A21&\")\",\"\")","v":"Approved (A) / Approved with remark (B) / Refuses (C) / Non concerned (D)"}]
[]
["STAKEHOLDERS",null,null,"AR","STAB","MEP",null,null,null,null,null,null,null,"PM"]
["CONTIRBUTOR?",null,null,{"$f":"IF(D34 <> \"\", \"X\", \"\")","v":"X"},{"$f":"IF(E34 <> \"\", \"X\", \"\")","v":"X"},{"$f":"IF(F34 <> \"\", \"X\", \"\")","v":"X"},{"$f":"IF(G34 <> \"\", \"X\", \"\")","v":""},"","","","","","",{"$f":"IF(N34 <> \"\", \"X\", \"\")","v":"X"}]
["CONTRIBUTOR",null,null,"$(company_project_ar)","$(company_project_stab)","$(company_project_mep)",null,null,null,null,null,null,null,"$(company_project_pm)"]
["COMMENT",null,null,"$(actions.company_project_action_ar.company_project_comment)","$(actions.company_project_action_stab.company_project_comment)","$(actions.company_project_action_mep.company_project_comment)",null,null,null,null,null,null,null,"$(actions.company_project_action_pm.company_project_comment)"]
["DATE",null,null,"$(actions.company_project_action_ar.completedate)","$(actions.company_project_action_stab.completedate)","$(actions.company_project_action_mep.completedate)",null,null,null,null,null,null,null,"$(actions.company_project_action_pm.completedate)"]
["STATUS",null,null,"$(actions.company_project_action_ar.company_project_answer)","$(actions.company_project_action_stab.company_project_answer)","$(actions.company_project_action_mep.company_project_answer)",null,null,null,null,null,null,null,"$(actions.company_project_action_pm.company_project_answer)"]
["#ATTACHMENTS",null,null,"$(actions.company_project_action_ar.attachment_count)","$(actions.company_project_action_stab.attachment_count)","$(actions.company_project_action_mep.attachment_count)",null,null,null,null,null,null,null,"$(actions.company_project_action_pm.attachment_count)"]
["#ANNOTATIONS",null,null,"$(actions.company_project_action_ar.markup_count)","$(actions.company_project_action_stab.markup_count)","$(actions.company_project_action_mep.markup_count)",null,null,null,null,null,null,null,"$(actions.company_project_action_pm.markup_count)"]
["COMMENT?",null,null,{"$f":"IF(D35<>\"\",Config!$B$2,\"\")","v":"Oui"},{"$f":"IF(E35<>\"\",Config!$B$2,\"\")","v":"Oui"},{"$f":"IF(F35<>\"\",Config!$B$2,\"\")","v":"Oui"},null,null,null,null,null,null,null,{"$f":"IF(N35<>\"\",Config!$B$2,\"\")","v":"Oui"}]
["ATTACHMENTS?",null,null,{"$f":"IF(D38>0,Config!$B$2&\" (\"&D39&\")\",\"\")","v":"Oui ($(actions.company_project_action_ar.markup_count))"},{"$f":"IF(E38>0,Config!$B$2&\" (\"&E39&\")\",\"\")","v":"Oui ($(actions.company_project_action_stab.markup_count))"},{"$f":"IF(F38>0,Config!$B$2&\" (\"&F39&\")\",\"\")","v":"Oui ($(actions.company_project_action_mep.markup_count))"},null,null,null,null,null,null,null,{"$f":"IF(N38>0,Config!$B$2&\" (\"&N39&\")\",\"\")","v":"Oui ($(actions.company_project_action_pm.markup_count))"}]
["ANNOTATIONS?",null,null,{"$f":"IF(D39>0,Config!$B$2,\"\")","v":"Oui"},{"$f":"IF(E39>0,Config!$B$2,\"\")","v":"Oui"},{"$f":"IF(F39>0,Config!$B$2,\"\")","v":"Oui"},null,null,null,null,null,null,null,{"$f":"IF(N39>0,Config!$B$2,\"\")","v":"Oui"}]
[]
["Values"]
["${current_step}"]
["${completed_status}"]
["${life_status}"]

{"sheet":"Config","index":1,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Dictionnary"]
["Yes","Oui","Define word in own language"]
["No","Non"]
[]
[]
[]
["Statuses"]
["Positive","APPROVED"]
["Negative","REFUSED"]
["None","IN PROGRESS -"]
["Aborted","ABORTED"]
["Previous","Obsolete"]
["Current","In force"]
[]
["Answers"]
["A","Approved"]
["B","Approved with remark"]
["C","Refuses"]
["D","Non concerned"]
["Undefined"]
["Undefined"]

{"sheet":"Generator","index":2,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Step 1 - Initialization - Define values in yellow blocks and click on button"]
["Key Prefix","company_project"]
["Role Suffix","pm"]
["Displayed Role","pm"]
["Answer Key Suffix","answer"]
["Comment Key Suffix","comment"]
[]
["Step 2 - Footer generator"]
["STAKEHOLDERS","PM"]
["CONTIRBUTOR?",{"$f":"IF(B11 <> \"\", \"X\", \"\")","v":"X"}]
["CONTRIBUTOR","$(company_project_pm)"]
["COMMENT","$(actions.company_project_action_pm.company_project_comment)"]
["DATE","$(actions.company_project_action_pm.completedate)"]
["STATUS","$(actions.company_project_action_pm.company_project_answer)"]
["#ATTACHMENTS","$(actions.company_project_action_pm.attachment_count)"]
["#ANNOTATIONS","$(actions.company_project_action_pm.markup_count)"]
["COMMENT?",{"$f":"IF(B12<>\"\",Config!$B$2,\"\")","v":"Oui"}]
["ATTACHMENTS?",{"$f":"IF(B15>0,Config!$B$2&\" (\"&B16&\")\",\"\")","v":"Oui ($(actions.company_project_action_pm.markup_count))"}]
["ANNOTATIONS?",{"$f":"IF(B16>0,Config!$B$2,\"\")","v":"Oui"}]
[]
["Step 3 - Copy all rows and paster in cover footer as formulas"]